﻿SELECT TABLE_SCHEMA 'Schema', TABLE_NAME 'Table' 
FROM  INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE='BASE TABLE'